
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
About the extended attribute system tables</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="pbugp283.htm">Previous</A>&nbsp;&nbsp;<A HREF="pbugp285.htm" >Next</A>
<!-- End Header -->
<A NAME="X-REF298232540"></A><h1>About the extended attribute system tables</h1>
<A NAME="TI10314"></A><p>PowerBuilder stores application-based information you provide
for a database table (such as the text to use for labels and headings
for the columns, validation rules, display formats, and edit styles)
in system tables in your database. These system tables are called
the extended attribute system tables. The tables contain all the
information related to the extended attributes for the tables and
columns in the database. The extended attributes are used in DataWindow objects.</p>
<A NAME="TI10315"></A><h4>The system tables</h4>
<A NAME="TI10316"></A><p>There are five extended attribute system tables.</p>
<A NAME="TI10317"></A><table cellspacing=0 cellpadding=6 border=1 frame="void" rules="all"><caption>Table A-1: List of extended attribute system tables</caption>
<tr><th  rowspan="1"  ><A NAME="TI10318"></A>Table</th>
<th  rowspan="1"  ><A NAME="TI10319"></A>Contains information about</th>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI10320"></A><b>PBCatTbl</b></td>
<td  rowspan="1"  ><A NAME="TI10321"></A>Tables in the database</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI10322"></A><b>PBCatCol</b></td>
<td  rowspan="1"  ><A NAME="TI10323"></A>Columns in the database</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI10324"></A><b>PBCatFmt</b></td>
<td  rowspan="1"  ><A NAME="TI10325"></A>Display formats</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI10326"></A><b>PBCatVld</b></td>
<td  rowspan="1"  ><A NAME="TI10327"></A>Validation rules</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI10328"></A><b>PBCatEdt</b></td>
<td  rowspan="1"  ><A NAME="TI10329"></A>Edit styles</td>
</tr>
</table>
<A NAME="TI10330"></A><h4>What to do with the tables</h4>
<A NAME="TI10331"></A><p>You can open and look at these tables in the Database painter just
like other tables. You might want to create a report of the extended
attribute information used in your database by building a DataWindow object whose
data source is the extended attribute system tables.</p>
<p><img src="images/note.gif" width=17 height=17 border=0 align="bottom" alt="Note"> <span class=shaded>Caution</span> <A NAME="TI10332"></A>You should not change the values in the extended attribute
system tables. PowerBuilder maintains this information automatically
whenever you change information for a table or column in the Database painter.</p>

